Paul McGuinness
Paul McGuinness
Reactions
-
Re: Template Idea for 1:1
Hi @maltaee In that case you can create a single report of the sheet and just allocate each row using a contact column in the master sheet. i.e. Create a report then filter the report by current user…1 · -
Re: Create Formula in Sheet Summary field to pull only Month from another Sheet Summary Date Field
Hi @MariaG Thats fine, if we add another IF using ISBLANK at the front of the formula we can achieve that. =IF(ISBLANK([Projected completion date]#), "Undecided", IF(MONTH([Projected comple…1 · -
Re: Welcome to the Healthcare & Life Sciences Community!
Hi everyone! I'm Paul McGuinness, a Central Operations manager for Care UK. Who are a residential care company for the elderly operating across 150+ sites in the UK. I've been using Smartsheet for ov…8 · -
Re: Assign duration on dropdown list items and update dates accordingly
Hi @EdwardH Really interesting question. I was able to make this work but it did require 4 helper columns to do so that you can hide. Below is the working visual Formulas: Next milestone date column …1 · -
Re: Date Range Validation
Hi @Jason Voorhies Based on having a start and end date column this formula would do that =NETWORKDAY([Start date]), [End date]) * [Hourly Rate]@row * [Hrs/week]@row / 5 the formula will just account…1 ·
